﻿using System.Collections.Generic;
using System.Data;
using Unis.Framework.RuleBase.Common;
using KingRoad.EPM.PersonnelLogEntity.Model;

namespace KingRoad.EPM.PersonnelLogDAL.ScmSafetyconstructiondicService
{    
    /// <summary> 
    /// 文件生成时间 2017/1/12 11:36:11
    /// </summary> 
    public class ScmSafetyconstructiondicService :BaseService<ScmSafetyconstructiondicInfo>, IScmSafetyconstructiondicService
    {
        public DataTable GetSafetyconstructiondicByPIDs(string sql)
        {
            var strSql = "SELECT Scd_Name FROM Scm_SafetyConstructionDic WHERE " + sql + "  group by scd_name ";

            var dt = DatabaseExcuteBySql.QuerybySql(strSql);
            return dt;
        }

    }

}
